package com.mh.dao;

import com.mh.domain.Customer;

import java.util.Date;
import java.util.Set;

import org.skyway.spring.util.dao.JpaDao;

import org.springframework.dao.DataAccessException;
import org.springframework.transaction.annotation.Transactional;

/**
 * DAO to manage Customer entities.
 * 
 */
public interface CustomerDAO extends JpaDao<Customer> {

	/**
	 * JPQL Query - findCustomerByModifiedByContaining
	 *
	 */
	public Set<Customer> findCustomerByModifiedByContaining(String modifiedBy) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByModifiedByContaining
	 *
	 */
	public Set<Customer> findCustomerByModifiedByContaining(String modifiedBy, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByBirthday
	 *
	 */
	public Set<Customer> findCustomerByBirthday(java.util.Date birthday) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByBirthday
	 *
	 */
	public Set<Customer> findCustomerByBirthday(Date birthday, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByFirstNameContaining
	 *
	 */
	public Set<Customer> findCustomerByFirstNameContaining(String firstName) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByFirstNameContaining
	 *
	 */
	public Set<Customer> findCustomerByFirstNameContaining(String firstName, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByModifiedOn
	 *
	 */
	public Set<Customer> findCustomerByModifiedOn(java.util.Date modifiedOn) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByModifiedOn
	 *
	 */
	public Set<Customer> findCustomerByModifiedOn(Date modifiedOn, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCityContaining
	 *
	 */
	public Set<Customer> findCustomerByCityContaining(String city) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCityContaining
	 *
	 */
	public Set<Customer> findCustomerByCityContaining(String city, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerById
	 *
	 */
	public Customer findCustomerById(Integer id) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerById
	 *
	 */
	public Customer findCustomerById(Integer id, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCity
	 *
	 */
	public Set<Customer> findCustomerByCity(String city_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCity
	 *
	 */
	public Set<Customer> findCustomerByCity(String city_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCreatedBy
	 *
	 */
	public Set<Customer> findCustomerByCreatedBy(String createdBy) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCreatedBy
	 *
	 */
	public Set<Customer> findCustomerByCreatedBy(String createdBy, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByFirstName
	 *
	 */
	public Set<Customer> findCustomerByFirstName(String firstName_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByFirstName
	 *
	 */
	public Set<Customer> findCustomerByFirstName(String firstName_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByAddress
	 *
	 */
	public Set<Customer> findCustomerByAddress(String address) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByAddress
	 *
	 */
	public Set<Customer> findCustomerByAddress(String address, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCreatedByContaining
	 *
	 */
	public Set<Customer> findCustomerByCreatedByContaining(String createdBy_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCreatedByContaining
	 *
	 */
	public Set<Customer> findCustomerByCreatedByContaining(String createdBy_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByEmail
	 *
	 */
	public Set<Customer> findCustomerByEmail(String email) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByEmail
	 *
	 */
	public Set<Customer> findCustomerByEmail(String email, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByLastNameContaining
	 *
	 */
	public Set<Customer> findCustomerByLastNameContaining(String lastName) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByLastNameContaining
	 *
	 */
	public Set<Customer> findCustomerByLastNameContaining(String lastName, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByEmailContaining
	 *
	 */
	public Set<Customer> findCustomerByEmailContaining(String email_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByEmailContaining
	 *
	 */
	public Set<Customer> findCustomerByEmailContaining(String email_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByAddressContaining
	 *
	 */
	public Set<Customer> findCustomerByAddressContaining(String address_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByAddressContaining
	 *
	 */
	public Set<Customer> findCustomerByAddressContaining(String address_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCreatedOn
	 *
	 */
	public Set<Customer> findCustomerByCreatedOn(java.util.Date createdOn) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByCreatedOn
	 *
	 */
	public Set<Customer> findCustomerByCreatedOn(Date createdOn, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByPrimaryKey
	 *
	 */
	public Customer findCustomerByPrimaryKey(Integer id_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByPrimaryKey
	 *
	 */
	public Customer findCustomerByPrimaryKey(Integer id_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByLastName
	 *
	 */
	public Set<Customer> findCustomerByLastName(String lastName_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByLastName
	 *
	 */
	public Set<Customer> findCustomerByLastName(String lastName_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByModifiedBy
	 *
	 */
	public Set<Customer> findCustomerByModifiedBy(String modifiedBy_1) throws DataAccessException;

	/**
	 * JPQL Query - findCustomerByModifiedBy
	 *
	 */
	public Set<Customer> findCustomerByModifiedBy(String modifiedBy_1, int startResult, int maxRows) throws DataAccessException;

	/**
	 * JPQL Query - findAllCustomers
	 *
	 */
	public Set<Customer> findAllCustomers() throws DataAccessException;

	/**
	 * JPQL Query - findAllCustomers
	 *
	 */
	public Set<Customer> findAllCustomers(int startResult, int maxRows) throws DataAccessException;
	
	
	@Transactional
	public Set<Customer> findCustomers(Customer customer) throws DataAccessException ;

}